package pe.edu.sistemas.sisdiho.mappers;

import java.util.List;

import pe.edu.sistemas.sisdiho.entities.Aula;

import org.apache.ibatis.annotations.Select;

public interface AulaMapper {
	@Select("SELECT a.IDAULA as id ,"
			+ " a.CAPACIDAD as capacidad,"
			+ " a.NOMBRE as nomb,"
			+ " a.TIPO_AULA as tipo_aula,"
			+ " a.PISO as piso "
			+ "FROM AULA a "
			+ "WHERE (a.TIPO_AULA=1 OR a.TIPO_AULA=3) "
			+ "AND NOT (a.IDAULA=21) " )
	public List<Aula> obtenerListaAulas();
	@Select("SELECT a.IDAULA as id ,"
			+ " a.CAPACIDAD as capacidad,"
			+ " a.NOMBRE as nomb,"
			+ " a.TIPO_AULA as tipo_aula,"
			+ " a.PISO as piso "
			+ "FROM AULA a "
			+ "WHERE a.TIPO_AULA=3 "
			+ "AND a.IDAULA=21 " )
	public Aula obtenerListaMagna();
	@Select("SELECT a.IDAULA as id ,"
			+ " a.CAPACIDAD as capacidad,"
			+ " a.NOMBRE as nomb,"
			+ " a.TIPO_AULA as tipo_aula,"
			+ " a.PISO as piso "
			+ "FROM AULA a "
			+ "WHERE a.TIPO_AULA=2 " )
	public List<Aula> obtenerListaLaboratorios();
}
